UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'p7b0a7Ro/ZYENKzIbCl0xLn3fuGlvE9FiBW/v9BcHrg=' 
WHERE 
  key_id = '9550dd2eeb8109ecfec324e4ce96b6f8d9665a84ed402ad62aa3582c7e600b10' 
  AND (
    token = 'p7b0a7Ro/ZYENKzIbCl0xLn3fuGlvE9FiBW/v9BcHrg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037