UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z2DFW45yIDCwS9301XqpvGUn3NUDXX019pEpO8ih7SM='
WHERE
key_id = 'e505dc56a419f7aca8816574db6c5a1b7051c9e8caae3a4a315ecb9da2aa47b4'
AND (
token = 'Z2DFW45yIDCwS9301XqpvGUn3NUDXX019pEpO8ih7SM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)