UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '05q87nBz5i6ThA3sh+QueKpcNRdJr/P6sYYr2TyzP5w=' 
WHERE 
  key_id = '7a00ede00c009efb6861ac464b49b9f6ec397a6c1e25dc485c5138bcfbe6f7d5' 
  AND (
    token = '05q87nBz5i6ThA3sh+QueKpcNRdJr/P6sYYr2TyzP5w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032