UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcg914IlZD48haD9hGLJVW8/ZfhyJLhz1TaDfni8FEM='
WHERE
key_id = '973722b9e5b670bf85eb04eb7104a028fe91cdc35d39c9d65b7179a1dc44943e'
AND (
token = 'zcg914IlZD48haD9hGLJVW8/ZfhyJLhz1TaDfni8FEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)