UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XvrOHh/9BNydaTB4g139X8USR3rN0Hc84V3O7AqtS9E='
WHERE
key_id = '90b14b27e3322332f4a2f23f315e1e516796ee97c2222fb8ba4374a96ff7565b'
AND (
token = 'XvrOHh/9BNydaTB4g139X8USR3rN0Hc84V3O7AqtS9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)