UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qGaxKic3BxrnrnF6+k2s3v93VfVg/5W+ruf/V1QJX4='
WHERE
key_id = 'c4fa01d47a334fd91bcf2ad9db9c63a94af0360382a388861c01710f972c3f11'
AND (
token = '0qGaxKic3BxrnrnF6+k2s3v93VfVg/5W+ruf/V1QJX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)