UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xk+RskjpNblkn1pP6RCFoCfuKA4g/3ORokt3nqS7kHI='
WHERE
key_id = '195860335ce2d55493062884a4547982bf33ccda1571ae775c7b7de2c883f37b'
AND (
token = 'xk+RskjpNblkn1pP6RCFoCfuKA4g/3ORokt3nqS7kHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)