UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kA+1d3Xl+ckQPFQY6g7qn12HpLjZVePHQWCJ6pvNlSA='
WHERE
key_id = '4a567e651c85013693d8c4f047a1a7f60ac6cae0b0cd82892cab5b4f0a990fa6'
AND (
token = 'kA+1d3Xl+ckQPFQY6g7qn12HpLjZVePHQWCJ6pvNlSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)