UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IbPxIhpY0P+Jn4XQUdNR9mw3fhHk00EgrlelG17TkFk=' 
WHERE 
  key_id = '23f3ba0391464aa1fce15c5d5566e08b35df9f23f34fa5170755ef9216f22801' 
  AND (
    token = 'IbPxIhpY0P+Jn4XQUdNR9mw3fhHk00EgrlelG17TkFk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028