UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nfXNqPyhTYjCvydjB3BOp2o8g3oEglLsNmNNqy4UKA0='
WHERE
key_id = '2c90a19b81b7305d90ea9c66260694fc380a9c84080d227d4ef02e48d5c6773a'
AND (
token = 'nfXNqPyhTYjCvydjB3BOp2o8g3oEglLsNmNNqy4UKA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)