UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rmAizzmANMnaI+gsIS7ZqAAetAP/m/18TfL2FBKaG7c='
WHERE
key_id = 'bb88bd9c77ffe59f66b946090d4da6ff9cfdd0451ef197c1d90dc4e122282a70'
AND (
token = 'rmAizzmANMnaI+gsIS7ZqAAetAP/m/18TfL2FBKaG7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)