UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q30W3I1k5ACoDlsbsS0tTUguahHaUXEc1c2Tn3xJaGw='
WHERE
key_id = '29f82db3d6973e4d68abf91c065a57e067cefd4c40d3d9c22740624d7501b0d6'
AND (
token = 'q30W3I1k5ACoDlsbsS0tTUguahHaUXEc1c2Tn3xJaGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)