UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pamzgwLj7CZVRMuzZGjgbMeRxvcrlObAhpwZkTdeenA='
WHERE
key_id = '50e98773ff0eb5acff9d1882ee9065866b7c0f28ac6f903be1a27463f75a4207'
AND (
token = 'pamzgwLj7CZVRMuzZGjgbMeRxvcrlObAhpwZkTdeenA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)