UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ROIwFnteBGL9NItUa+I1F4jqScGTPhe9ANym0cmuOKM=' 
WHERE 
  key_id = 'a01767d1f506ac27d72e27606e191a8fc4bea9e5219946154ae69e253b28abc5' 
  AND (
    token = 'ROIwFnteBGL9NItUa+I1F4jqScGTPhe9ANym0cmuOKM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030