UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ztXrp4KS6RLG9mcCb3f8jHh7aR/jTN3fSw17a7h3WiQ='
WHERE
key_id = '3a16b37dd12a5b65eaf4060421548a4228d022e28d94c0bdc69b9ce9de084cb3'
AND (
token = 'ztXrp4KS6RLG9mcCb3f8jHh7aR/jTN3fSw17a7h3WiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)