UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BRZnfPswmwQQ0BI0jgmiaxeT0FZf63jovk3CakN5cbc=' 
WHERE 
  key_id = '246cb886628b9690561afd96b76177c34ec2d22e2c44c1cc1019a5229414e178' 
  AND (
    token = 'BRZnfPswmwQQ0BI0jgmiaxeT0FZf63jovk3CakN5cbc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027