UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TPXhx4FZPn5HBoLQPM9zYTESP7uOgKCtHlnKaKGUdtU='
WHERE
key_id = '3a84e825e7c16d4270ca3d23c720749bd2efed359cf47b5e0e9faefb83ef5687'
AND (
token = 'TPXhx4FZPn5HBoLQPM9zYTESP7uOgKCtHlnKaKGUdtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)