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