UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRJrOfUtZpXiE8qjNM/MNI9IFow9OALplCmOt2O2y4U='
WHERE
key_id = '29bc30523e046233cf549785aea9640f7c86ca617456afe648ef25aabaf6082b'
AND (
token = 'lRJrOfUtZpXiE8qjNM/MNI9IFow9OALplCmOt2O2y4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)