UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'geSsfhdy8VBdZgMOoZYK++T3v1+amZ1t9NI9A55Xnac='
WHERE
key_id = 'faee8060aec10440a35ff4f2b2b75c813fbf874f898f4d35ebd247a3f12ee2b6'
AND (
token = 'geSsfhdy8VBdZgMOoZYK++T3v1+amZ1t9NI9A55Xnac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)