UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h33c2HEHRxA03HPr1YL/qGV83S+80jZG1mrq1ACk2QQ=' 
WHERE 
  key_id = 'dbf69fd28782774d2201a7bfc1527329d737ba082b9eb11a85ce7443dff77c96' 
  AND (
    token = 'h33c2HEHRxA03HPr1YL/qGV83S+80jZG1mrq1ACk2QQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032