UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cpXFhXzb6kDZimuwOGQode4WmXr7wywrQhX1/awSzSc=' 
WHERE 
  key_id = '12613761208c3f12c761c797b0a49404b5477a8558cdc5a90e534212a5888eb9' 
  AND (
    token = 'cpXFhXzb6kDZimuwOGQode4WmXr7wywrQhX1/awSzSc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054