UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3cnqYSEBPBWyq4cd4+zO9aBgNanO6k6Afjiw8Zo2puQ='
WHERE
key_id = '239120c4bc1c1eec1d315ca14822f3dc77faf372a4a87979b985d732ba933700'
AND (
token = '3cnqYSEBPBWyq4cd4+zO9aBgNanO6k6Afjiw8Zo2puQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)