UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCw2LMA/HmE3PZplH9R50RNF0xYbrx7QPHwkgzBh+3E='
WHERE
key_id = 'fb570e90f6b7896c4351e5844d10c8c21a562981c163e44d98c8363d04ee6852'
AND (
token = 'zCw2LMA/HmE3PZplH9R50RNF0xYbrx7QPHwkgzBh+3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)