UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vG0a7v8cfD3gG/hNBNPffO3GY1VIli70xjiX+KdONkY=' 
WHERE 
  key_id = '4398051b98c1a84c171f6abf915ae6f4beb8ac1d3a6a1a6ac5b528cb01e31d06' 
  AND (
    token = 'vG0a7v8cfD3gG/hNBNPffO3GY1VIli70xjiX+KdONkY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00069