UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Acop29g8Y78gAEBhGJ0ph+auGyrvWcHZX8jSRDPDnh4='
WHERE
key_id = '1e6343e60543bbc4e646066825fdbaef116f777e3ae03c3fca154b4c59a51b56'
AND (
token = 'Acop29g8Y78gAEBhGJ0ph+auGyrvWcHZX8jSRDPDnh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)