UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BF4LnKp7RsBLgwpOO1+DD283rloSK2K+1uN0oYyIrpA=' 
WHERE 
  key_id = '0a63e70154e039f6c2d44713066c0ed57fd1bfcecde5113d3a98b8b0c279d157' 
  AND (
    token = 'BF4LnKp7RsBLgwpOO1+DD283rloSK2K+1uN0oYyIrpA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054