UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHi/lQ40Kl3G541wIh6noI3qQqCy3HxqI7WWtalC4YA='
WHERE
key_id = '457cdc06f2a8d1de7b65a1261199ab5ccf7638f981d9e69d4afe6eb4486a76b1'
AND (
token = 'gHi/lQ40Kl3G541wIh6noI3qQqCy3HxqI7WWtalC4YA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)