UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pd1Asj3I9CMyibKZ0qFBKnoOsotA7bsueUAG07AdyoI='
WHERE
key_id = 'e585388e059dd6480bc9be93c93382601d44ece01313929f65524767ce0c13c2'
AND (
token = 'Pd1Asj3I9CMyibKZ0qFBKnoOsotA7bsueUAG07AdyoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)