UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w/ZclZw3e0+umViCVqFSdY5b7KVcuhxHWk73sy5COrk='
WHERE
key_id = '244695731ce84148c91a908f9fe45f6bdb309b97a70df78492f2ab233056e5d2'
AND (
token = 'w/ZclZw3e0+umViCVqFSdY5b7KVcuhxHWk73sy5COrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)