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