UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZXmYZA8Zt7OAw82l3UXH+okOp0H9LP1EWgadsT9kcs='
WHERE
key_id = '3e3f6c5e646e5b20205bd96c65beef550def52e21258aa79e0aa1e8fba84e65b'
AND (
token = '/ZXmYZA8Zt7OAw82l3UXH+okOp0H9LP1EWgadsT9kcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)