UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W/HvlzX0uQMpP2pXDTFaR3AEy+nGMoP5MWj/0Lx3x28=' 
WHERE 
  key_id = '296b560fb26b0c627ac6ea5ccdded05146609b11059ff66aab8c85031c27caa5' 
  AND (
    token = 'W/HvlzX0uQMpP2pXDTFaR3AEy+nGMoP5MWj/0Lx3x28=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034