UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xxzAiUJ+QozNHqntcW1vqezCxcbX+iDL3BOo3u0adb8='
WHERE
key_id = '77cf278a7e8076175026eb21b5254bd903ae6f8dfa14740d42452fb9ecdf885c'
AND (
token = 'xxzAiUJ+QozNHqntcW1vqezCxcbX+iDL3BOo3u0adb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)