UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cinhI51Dh79jgsnIop8wf/OvLOMgAlm3KW19j2iSk+8='
WHERE
key_id = 'e07cbd6359bb2392148a5f6ae733132635e5dfbec0e3d66bc00a285ca25ae219'
AND (
token = 'cinhI51Dh79jgsnIop8wf/OvLOMgAlm3KW19j2iSk+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)