UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nyg8byxtV7qVkY0SFsYA1vu6EegetAlgBvAXhsSX8Pw='
WHERE
key_id = '0645a58d60dccb65a1ce66e4adf5d7c12c488118de8b699077a209c44d9381bc'
AND (
token = 'Nyg8byxtV7qVkY0SFsYA1vu6EegetAlgBvAXhsSX8Pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)