UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfNxtoHykYRtlpMR5igt8S+Dsv1V/IFbKGpiJMmg7RY='
WHERE
key_id = 'd3fe9894bb8b67ffffd55bad1837e7d596a9633048947945bc69ac2b7deec6de'
AND (
token = 'AfNxtoHykYRtlpMR5igt8S+Dsv1V/IFbKGpiJMmg7RY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)